----------------------------------------------------------------
-- Aggregation function to join text.
--
-- Usage example:
--	SELECT order_code, RTRIM(aggr_string_join(product_name || ', '), ', ')
--		FROM order_detail GROUP BY order_code
--
----------------------------------------------------------------

CREATE OR REPLACE FUNCTION aggr_string_join(psText IN VARCHAR2)
	RETURN VARCHAR2
	DETERMINISTIC
	PARALLEL_ENABLE
	AGGREGATE USING aggr_string_join_t;
/
show errors
